package com.csust.travel.mapper;

import com.csust.travel.entity.CollegeReport;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CollegeReportMapper {

    @Select("SELECT college, COUNT(*) AS value\n" +
            "FROM sellers\n" +
            "GROUP BY college;")
    List<CollegeReport> findNameAndNumber();
}
